package com.hrd.mybatis.bean.auto;

import java.util.ArrayList;
import java.util.List;

public class SqbInvInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitEnd = -1;

    public SqbInvInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    public int getLimitStart() {
        return limitStart;
    }

    public void setLimitEnd(int limitEnd) {
        this.limitEnd=limitEnd;
    }

    public int getLimitEnd() {
        return limitEnd;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andSpidIdIsNull() {
            addCriterion("spid_id is null");
            return (Criteria) this;
        }

        public Criteria andSpidIdIsNotNull() {
            addCriterion("spid_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpidIdEqualTo(String value) {
            addCriterion("spid_id =", value, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdNotEqualTo(String value) {
            addCriterion("spid_id <>", value, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdGreaterThan(String value) {
            addCriterion("spid_id >", value, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdGreaterThanOrEqualTo(String value) {
            addCriterion("spid_id >=", value, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdLessThan(String value) {
            addCriterion("spid_id <", value, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdLessThanOrEqualTo(String value) {
            addCriterion("spid_id <=", value, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdLike(String value) {
            addCriterion("spid_id like", value, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdNotLike(String value) {
            addCriterion("spid_id not like", value, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdIn(List<String> values) {
            addCriterion("spid_id in", values, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdNotIn(List<String> values) {
            addCriterion("spid_id not in", values, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdBetween(String value1, String value2) {
            addCriterion("spid_id between", value1, value2, "spidId");
            return (Criteria) this;
        }

        public Criteria andSpidIdNotBetween(String value1, String value2) {
            addCriterion("spid_id not between", value1, value2, "spidId");
            return (Criteria) this;
        }

        public Criteria andStockidNameIsNull() {
            addCriterion("stockid_name is null");
            return (Criteria) this;
        }

        public Criteria andStockidNameIsNotNull() {
            addCriterion("stockid_name is not null");
            return (Criteria) this;
        }

        public Criteria andStockidNameEqualTo(String value) {
            addCriterion("stockid_name =", value, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameNotEqualTo(String value) {
            addCriterion("stockid_name <>", value, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameGreaterThan(String value) {
            addCriterion("stockid_name >", value, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameGreaterThanOrEqualTo(String value) {
            addCriterion("stockid_name >=", value, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameLessThan(String value) {
            addCriterion("stockid_name <", value, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameLessThanOrEqualTo(String value) {
            addCriterion("stockid_name <=", value, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameLike(String value) {
            addCriterion("stockid_name like", value, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameNotLike(String value) {
            addCriterion("stockid_name not like", value, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameIn(List<String> values) {
            addCriterion("stockid_name in", values, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameNotIn(List<String> values) {
            addCriterion("stockid_name not in", values, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameBetween(String value1, String value2) {
            addCriterion("stockid_name between", value1, value2, "stockidName");
            return (Criteria) this;
        }

        public Criteria andStockidNameNotBetween(String value1, String value2) {
            addCriterion("stockid_name not between", value1, value2, "stockidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameIsNull() {
            addCriterion("materialid_name is null");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameIsNotNull() {
            addCriterion("materialid_name is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameEqualTo(String value) {
            addCriterion("materialid_name =", value, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameNotEqualTo(String value) {
            addCriterion("materialid_name <>", value, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameGreaterThan(String value) {
            addCriterion("materialid_name >", value, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameGreaterThanOrEqualTo(String value) {
            addCriterion("materialid_name >=", value, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameLessThan(String value) {
            addCriterion("materialid_name <", value, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameLessThanOrEqualTo(String value) {
            addCriterion("materialid_name <=", value, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameLike(String value) {
            addCriterion("materialid_name like", value, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameNotLike(String value) {
            addCriterion("materialid_name not like", value, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameIn(List<String> values) {
            addCriterion("materialid_name in", values, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameNotIn(List<String> values) {
            addCriterion("materialid_name not in", values, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameBetween(String value1, String value2) {
            addCriterion("materialid_name between", value1, value2, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNameNotBetween(String value1, String value2) {
            addCriterion("materialid_name not between", value1, value2, "materialidName");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberIsNull() {
            addCriterion("materialid_number is null");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberIsNotNull() {
            addCriterion("materialid_number is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberEqualTo(String value) {
            addCriterion("materialid_number =", value, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberNotEqualTo(String value) {
            addCriterion("materialid_number <>", value, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberGreaterThan(String value) {
            addCriterion("materialid_number >", value, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberGreaterThanOrEqualTo(String value) {
            addCriterion("materialid_number >=", value, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberLessThan(String value) {
            addCriterion("materialid_number <", value, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberLessThanOrEqualTo(String value) {
            addCriterion("materialid_number <=", value, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberLike(String value) {
            addCriterion("materialid_number like", value, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberNotLike(String value) {
            addCriterion("materialid_number not like", value, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberIn(List<String> values) {
            addCriterion("materialid_number in", values, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberNotIn(List<String> values) {
            addCriterion("materialid_number not in", values, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberBetween(String value1, String value2) {
            addCriterion("materialid_number between", value1, value2, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andMaterialidNumberNotBetween(String value1, String value2) {
            addCriterion("materialid_number not between", value1, value2, "materialidNumber");
            return (Criteria) this;
        }

        public Criteria andQtyIsNull() {
            addCriterion("qty is null");
            return (Criteria) this;
        }

        public Criteria andQtyIsNotNull() {
            addCriterion("qty is not null");
            return (Criteria) this;
        }

        public Criteria andQtyEqualTo(String value) {
            addCriterion("qty =", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotEqualTo(String value) {
            addCriterion("qty <>", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThan(String value) {
            addCriterion("qty >", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThanOrEqualTo(String value) {
            addCriterion("qty >=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThan(String value) {
            addCriterion("qty <", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThanOrEqualTo(String value) {
            addCriterion("qty <=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLike(String value) {
            addCriterion("qty like", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotLike(String value) {
            addCriterion("qty not like", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyIn(List<String> values) {
            addCriterion("qty in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotIn(List<String> values) {
            addCriterion("qty not in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyBetween(String value1, String value2) {
            addCriterion("qty between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotBetween(String value1, String value2) {
            addCriterion("qty not between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andStockidIdIsNull() {
            addCriterion("stockid_id is null");
            return (Criteria) this;
        }

        public Criteria andStockidIdIsNotNull() {
            addCriterion("stockid_id is not null");
            return (Criteria) this;
        }

        public Criteria andStockidIdEqualTo(String value) {
            addCriterion("stockid_id =", value, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdNotEqualTo(String value) {
            addCriterion("stockid_id <>", value, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdGreaterThan(String value) {
            addCriterion("stockid_id >", value, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdGreaterThanOrEqualTo(String value) {
            addCriterion("stockid_id >=", value, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdLessThan(String value) {
            addCriterion("stockid_id <", value, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdLessThanOrEqualTo(String value) {
            addCriterion("stockid_id <=", value, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdLike(String value) {
            addCriterion("stockid_id like", value, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdNotLike(String value) {
            addCriterion("stockid_id not like", value, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdIn(List<String> values) {
            addCriterion("stockid_id in", values, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdNotIn(List<String> values) {
            addCriterion("stockid_id not in", values, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdBetween(String value1, String value2) {
            addCriterion("stockid_id between", value1, value2, "stockidId");
            return (Criteria) this;
        }

        public Criteria andStockidIdNotBetween(String value1, String value2) {
            addCriterion("stockid_id not between", value1, value2, "stockidId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
